169

A Little Bit of Computer Science

169

Open

A statement that opens a file with a given directory path name

Operation

An operation is a programming construct that denotes a simple

action with variables and/​or constants

An operation can be

Add

Subtract

Multiply

Divide

Modulus

Exponentiation

Example:

variable X=​5 and variable Y=​10

Operator    Description                Example

+​    Adds the two operands        X+​Y =​ 15

-​    Subtracts the second operand

  from the first    X-​Y =​ 5

*    Multiplies both the operands    X*Y =​ 50

/​    Divides the numerator by

  the denominator    X/​Y =​ 2

%    Modulus operator and the

  remainder after an

  integer division    X%Y =​ 0

^    Exponentiation operator    Y^X =​ 100000

OptionButton

Button on a form that is part of a set that functions like radio

buttons—​i.e. only one in the set can be selected

Parameter

Values that are passed to a block of code that is referred to as a

Subroutine (Sub) or Function

Public

A variable declaration that is valid across all subroutines and

functions. Normally, a variable is only available in a program and

not in the program it calls. A variable declared with PUBLIC is

available everywhere until execution stops

Recursion

Code that calls itself repetitively in a controlled manner

Select

Used along with the name of an object such as a sheet or a range,

this verb has the same effect as selecting multiple cells in a

spreadsheet. You can take action on this set of cells by referring

to the selected objects as a “selection”

Selection

The selected set of objects after executing a “select” statement

Set

A statement to assign a constant to a variable

Sheets

Worksheet reference

ShellExecute

Execute an operating system command outside excel

Show

Display

ShowType

The type of presentation of a powerpoint deck

Sleep

A function that is used to pause processing for N seconds where N

is a number defined in the sleep statement—​sleep(N)